Edinburgh’s road network
Edinburgh’s implementation zones
Edinburgh’s control zones
Time series analysis
Mapping accidents with roads: 2013
## LAYER Accident_Index
## 1 20mph existing streets 49
## 2 20mph local streets 82
## 3 20mph main streets 206
## 4 30mph 109
## 5 40mph 60
## 6 50, 60 or 70mph 1
## 7 Part time 20mph 1
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 25
## 2 30 437
## 3 40 48
## LAYER Accident_Index
## 1 20mph existing streets 48
## 2 20mph local streets 72
## 3 20mph main streets 182
## 4 30mph 98
## 5 40mph 43
## 6 50, 60 or 70mph 1
## 7 Part time 20mph 1
## 8 Trunk roads 2
## Speed_limit Accident_Index
## 1 20 25
## 2 30 387
## 3 40 35
Mapping accidents with roads: 2014
## LAYER Accident_Index
## 1 20mph existing streets 172
## 2 20mph local streets 172
## 3 20mph main streets 428
## 4 30mph 309
## 5 40mph 81
## 6 50, 60 or 70mph 22
## 7 Part time 20mph 11
## 8 Trunk roads 5
## Speed_limit Accident_Index
## 1 20 43
## 2 30 1075
## 3 40 82
Mapping accidents with roads: 2015
## LAYER Accident_Index
## 1 20mph existing streets 121
## 2 20mph local streets 188
## 3 20mph main streets 357
## 4 30mph 296
## 5 40mph 100
## 6 50, 60 or 70mph 17
## 7 Part time 20mph 6
## 8 Trunk roads 7
## Speed_limit Accident_Index
## 1 20 36
## 2 30 951
## 3 40 105
Mapping accidents with roads: 2016
## LAYER Accident_Index
## 1 20mph existing streets 56
## 2 20mph local streets 60
## 3 20mph main streets 26
## 4 30mph 32
## 5 40mph 19
## Speed_limit Accident_Index
## 1 20 8
## 2 30 164
## 3 40 21
Mapping accidents with roads: 2018
## LAYER Accident_Index
## 1 20mph existing streets 70
## 2 20mph local streets 96
## 3 20mph main streets 202
## 4 30mph 172
## 5 40mph 70
## 6 50, 60 or 70mph 7
## 7 Part time 20mph 13
## 8 Trunk roads 3
## Speed_limit Accident_Index
## 1 20 315
## 2 30 239
## 3 40 79
Mapping accidents with roads: 2019
## LAYER Accident_Index
## 1 20mph existing streets 31
## 2 20mph local streets 52
## 3 20mph main streets 87
## 4 30mph 77
## 5 40mph 24
## 6 50, 60 or 70mph 2
## 7 Part time 20mph 1
## 8 Trunk roads 1
## Speed_limit Accident_Index
## 1 20 153
## 2 30 97
## 3 40 25
Count pre 20mph
## LAYER Accident_Index
## 1 20mph existing streets 398
## 2 20mph local streets 502
## 3 20mph main streets 1017
## 4 30mph 746
## 5 40mph 260
## 6 50, 60 or 70mph 40
## 7 Part time 20mph 18
## 8 Trunk roads 14
## Speed_limit Accident_Index
## 1 20 112
## 2 30 2627
## 3 40 256
Count post 20mph
## LAYER Accident_Index
## 1 20mph existing streets 101
## 2 20mph local streets 148
## 3 20mph main streets 289
## 4 30mph 249
## 5 40mph 94
## 6 50, 60 or 70mph 9
## 7 Part time 20mph 14
## 8 Trunk roads 4
## Speed_limit Accident_Index
## 1 20 468
## 2 30 336
## 3 40 104
Output column: Layer
## ID Speed_limit LAYER
## 1 3815 20 20mph main streets
## 2 3816 20 20mph local streets
## 3 3818 40 20mph local streets
## 4 3819 20 30mph
## 5 3817 40 40mph
## 6 3820 30 30mph
Table: Average annual road traffic collision rates in the city of Edinburgh (GIS)
| Type | collisions pre-20mph | collisions post-20mph | rate pre-20mph | rate post-20mph | diff in rates | Perc.diff.rates |
|---|---|---|---|---|---|---|
| Streets at 30mph | 746 | 249 | 0.41 | 0.28 | 0.13 | 31.71 |
| Streets at 20mph | 398 | 101 | 0.22 | 0.11 | 0.11 | 50.00 |
| Streets at 30mph changed to 20mph | 1519 | 437 | 0.83 | 0.50 | 0.33 | 39.76 |
| Streets at 40mph | 260 | 94 | 0.14 | 0.11 | 0.03 | 21.43 |
| All streets | 1841 | 881 | 1.00 | 1.00 | 0.00 | 0.00 |
Table: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
| Type | collisions pre-20mph | collisions post-20mph | rate pre-20mph | rate post-20mph | diff in rates | Perc.diff.rates |
|---|---|---|---|---|---|---|
| Streets at 20mph | 112 | 468 | 0.04 | 0.52 | -0.48 | -12.00 |
| Streets at 30mph | 2627 | 336 | 0.88 | 0.37 | 0.51 | 0.58 |
| Streets at 40mph | 256 | 104 | 0.09 | 0.11 | -0.02 | -0.22 |
| All streets | 2995 | 908 | 1.00 | 1.00 | 0.00 | 0.00 |
Effect estimate (GIS)
| Tax year | 2013/14 | 2014/15 | 2015/16 | 2018/19 |
|---|---|---|---|---|
| Annual number of collisions | 1203 | 1103 | 689 | 908 |
| Effect estimate | 31.6 |
Effect estimate (Stats19)
| Tax year | 2013/14 | 2014/15 | 2015/16 | 2018/19 |
|---|---|---|---|---|
| Annual number of collisions | 1175 | 1074 | 674 | 881 |
| Effect estimate | 31.87 |
Mapping accidents with implementation zones: 2013
## ImplementationZone Accident_Index
## 1 1 73
## 2 2 105
## 3 3 137
## 4 4 44
## 5 5 68
## 6 6 30
## 7 7 21
Mapping accidents with implementation zones: 2014
## ImplementationZone Accident_Index
## 1 1 168
## 2 2 275
## 3 3 298
## 4 4 109
## 5 5 132
## 6 6 89
## 7 7 58
Mapping accidents with implementation zones: 2015
## ImplementationZone Accident_Index
## 1 1 155
## 2 2 210
## 3 3 273
## 4 4 75
## 5 5 144
## 6 6 91
## 7 7 43
Mapping accidents with implementation zones: 2016
## ImplementationZone Accident_Index
## 1 1 96
## 2 2 120
## 3 3 147
## 4 4 48
## 5 5 60
## 6 6 48
## 7 7 24
Mapping accidents with implementation zones: 2018
## ImplementationZone Accident_Index
## 1 1 88
## 2 2 125
## 3 3 160
## 4 4 53
## 5 5 68
## 6 6 46
## 7 7 30
Mapping accidents with implementation zones: 2019
## ImplementationZone Accident_Index
## 1 1 42
## 2 2 68
## 3 3 79
## 4 4 33
## 5 5 27
## 6 6 18
## 7 7 14
Output column: Implementation Zone
## Accident_Index Speed_limit ImplementationZone
## 1 2013950000001 30 1
## 2 2013950000002 30 2
## 3 2013950000003 30 2
## 4 2013950000007 30 1
## 5 2013950000010 30 4
## 6 2013950000058 20 7
Total accidents per zone
s <- s_13 + s_14 + s_15 + s_16 + s_18 + s_19
s$ImplementationZone <- s_13$ImplementationZone
s
## ImplementationZone Accident_Index
## 1 1 622
## 2 2 903
## 3 3 1094
## 4 4 362
## 5 5 499
## 6 6 322
## 7 7 190
Control zone 1a:City center –> George St/Harbour, Aberdeen
## [1] 81
Control zone 1b:Rural west –> Tay Bridgehead & St Andrews
## [1] 60
Control zone 3:South central –> Dundee
## [1] 494
Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West
## [1] 286
Control zone 5:West –> Glasgow Kelvin
## [1] 977
Control zone 6:South –> Paisley
## [1] 391
Updated dataset for Edinburgh
## Accident_Index Speed_limit LAYER Shape_Area
## 1 0000419 20 20mph main streets 17174685
## 2 0000519 20 20mph local streets 3385564
## 3 0000919 40 20mph local streets 29369816
## 4 0001019 20 30mph 17174685
## 5 0001219 40 40mph 15886220
## 6 0001419 30 30mph 15886220